COVID-19 in Italy. Visuals

(alternatively, see results and code together here)

 

Data source: this GitHubi page

Authors and sources mentioned: Editore/Autore del dataset: Dipartimento della Protezione Civile. Categoria ISO 19115: Salute. Dati forniti dal Ministero della Salute.

Regional data files (Dati per Regione):
  • Struttura file giornaliero: dpc-covid19-ita-regioni-yyyymmdd.csv (dpc-covid19-ita-regioni-20200224.csv)
  • File complessivo: dpc-covid19-ita-regioni.csv
  • File ultimi dati (latest): dpc-covid19-ita-regioni-latest.csv

 

Out[4]:

Currently data as of date: 2021-01-13T17:00:00

 

What's in the original dataframe?

Out[5]:

All column names: ['data', 'stato', 'codice_regione', 'denominazione_regione', 'lat', 'long', 'ricoverati_con_sintomi', 'terapia_intensiva', 'totale_ospedalizzati', 'isolamento_domiciliare', 'totale_positivi', 'variazione_totale_positivi', 'nuovi_positivi', 'dimessi_guariti', 'deceduti', 'casi_da_sospetto_diagnostico', 'casi_da_screening', 'totale_casi', 'tamponi', 'casi_testati', 'note', 'ingressi_terapia_intensiva', 'note_test', 'note_casi']

Out[6]:
data stato codice_regione denominazione_regione lat long ricoverati_con_sintomi terapia_intensiva totale_ospedalizzati isolamento_domiciliare ... deceduti casi_da_sospetto_diagnostico casi_da_screening totale_casi tamponi casi_testati note ingressi_terapia_intensiva note_test note_casi
6820 2021-01-13T17:00:00 ITA 19 Sicilia 38.115697 13.362357 1371 208 1579 43098 ... 2841 NaN NaN 113524 1333247 881698.0 NaN 14.0 NaN NaN
6821 2021-01-13T17:00:00 ITA 9 Toscana 43.769231 11.255889 738 140 878 7948 ... 3916 NaN NaN 126140 1988970 1099685.0 NaN 6.0 Positivi diagnosticati solo con test antigenic... NaN
6822 2021-01-13T17:00:00 ITA 10 Umbria 43.106758 12.388247 275 50 325 4145 ... 676 NaN NaN 31467 536852 263178.0 NaN 0.0 NaN NaN
6823 2021-01-13T17:00:00 ITA 2 Valle d'Aosta 45.737503 7.320149 43 2 45 375 ... 392 NaN NaN 7565 65735 40123.0 NaN 1.0 NaN NaN
6824 2021-01-13T17:00:00 ITA 5 Veneto 45.434905 12.338452 2551 336 2887 79083 ... 7684 NaN NaN 291719 3512029 1269858.0 Nei valori riportati per le terapie intensive ... 43.0 NaN NaN

5 rows × 24 columns

 

Variable names to English and their explanation

  • HospWithSymptoms : Currently hospitalized patients with symptoms
  • IC : Intensive care
  • HospTotal: Total number of currently hospitalized patients
  • AtHome : Currently at home confinement
  • CurrentlyPositive : Total amount of current positive cases (Hospitalised patients + Home confinement)
  • NewPositives : New amount of positive cases (Actual total amount of current positive cases - total amount of current positive cases of the previous day)
  • TotalCases : Total amount of positive cases
  • NoOfTests : Tests performed
Out[7]:
Date Region Lat Long HospWithSymptoms IC HospTotal AtHome CurrentlyPositive VariationOfPositives ... Diagnostico Screening TotalCases NoOfTests casi_testati note ingr_ter_intens note_test note_casi Pop
Date
2021-01-09 2021-01-09 Veneto 45.434905 12.338452 2540 349 2889 86562 89451 -1499 ... NaN NaN 283819 3451512 1255475.0 Nei valori riportati per le terapie intensive ... 32.0 NaN NaN 4905854
2021-01-10 2021-01-10 Veneto 45.434905 12.338452 2585 355 2940 85873 88813 -638 ... NaN NaN 285986 3466098 1259295.0 Nei valori riportati per le terapie intensive ... 37.0 NaN NaN 4905854
2021-01-11 2021-01-11 Veneto 45.434905 12.338452 2582 358 2940 84600 87540 -1273 ... NaN NaN 287701 3477099 1262079.0 Nei valori riportati per le terapie intensive ... 15.0 NaN NaN 4905854
2021-01-12 2021-01-12 Veneto 45.434905 12.338452 2596 359 2955 81770 84725 -2815 ... NaN NaN 289835 3492966 1266111.0 Nei valori riportati per le terapie intensive ... 44.0 NaN NaN 4905854
2021-01-13 2021-01-13 Veneto 45.434905 12.338452 2551 336 2887 79083 81970 -2755 ... NaN NaN 291719 3512029 1269858.0 Nei valori riportati per le terapie intensive ... 43.0 NaN NaN 4905854

5 rows × 23 columns

 

daily numbers & moving averages (MA)

(double click and click on legend to select one or multiple regions in the graph)

 

All regions together